/*
 Navicat Premium Data Transfer

 Source Server         : localhost(harry)
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : localhost:3306
 Source Schema         : harry

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 08/04/2021 12:15:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cms_article
-- ----------------------------
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article` (
                               `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                               `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
                               `type` tinyint(1) DEFAULT '1' COMMENT '文章类型[1:普通文章,5:帮助中心]',
                               `title` varchar(255) NOT NULL COMMENT '标题',
                               `summary` varchar(255) DEFAULT NULL COMMENT '文章摘要',
                               `tags` varchar(255) DEFAULT NULL COMMENT '文章标签',
                               `content` longtext COMMENT '内容',
                               `category` varchar(25) DEFAULT NULL COMMENT '分类',
                               `sub_category` varchar(25) DEFAULT NULL COMMENT '二级目录',
                               `open_count` int(11) DEFAULT '0' COMMENT '点击次数',
                               `start_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '生效时间',
                               `end_time` datetime DEFAULT NULL COMMENT '失效时间',
                               `target_link` varchar(255) DEFAULT NULL COMMENT '指向外链',
                               `image` varchar(255) DEFAULT NULL COMMENT '文章首图',
                               `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                               `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                               `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                               PRIMARY KEY (`id`) USING BTREE,
                               UNIQUE KEY `idx_title` (`title`) USING BTREE COMMENT '标题不得重复'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='CMS文章中心';

-- ----------------------------
-- Records of cms_article
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_captcha
-- ----------------------------
DROP TABLE IF EXISTS `sys_captcha`;
CREATE TABLE `sys_captcha` (
                               `uuid` varchar(36) NOT NULL COMMENT 'uuid',
                               `code` varchar(6) NOT NULL COMMENT '验证码',
                               `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
                               PRIMARY KEY (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='图片验证码';

-- ----------------------------
-- Records of sys_captcha
-- ----------------------------
BEGIN;
INSERT INTO `sys_captcha` VALUES ('1b5f808f1b1140db969a2654f35e7b94', 'nfbe8', '2021-04-16 15:57:09');
INSERT INTO `sys_captcha` VALUES ('332736be4cdf4f3cb022c35d62f03617', '66ape', '2021-04-10 16:26:14');
INSERT INTO `sys_captcha` VALUES ('35e9486992dd4428a352116a15abb6a2', '886b6', '2021-04-10 16:25:58');
INSERT INTO `sys_captcha` VALUES ('38c53fdf16b74412838aa18380e28a56', '2yy7g', '2021-04-10 09:51:33');
INSERT INTO `sys_captcha` VALUES ('3aae1ee2e2b648f7ba792bb020c37390', '73cf8', '2021-04-16 16:33:43');
INSERT INTO `sys_captcha` VALUES ('531eafe0722345909ced631d7ea5c53f', '3a225', '2021-04-10 16:11:34');
INSERT INTO `sys_captcha` VALUES ('54b35be3b3674a50862e7a209cb4f187', '4w2mg', '2021-04-16 16:11:13');
INSERT INTO `sys_captcha` VALUES ('5c07ce0d8f2149ac89532fcb3314abbf', 'wgpaf', '2021-04-16 14:39:44');
INSERT INTO `sys_captcha` VALUES ('5dd85d818ec64d23866ed4efc35d4292', 'ad7g5', '2021-04-09 14:24:55');
INSERT INTO `sys_captcha` VALUES ('66fabaac2114464994ebebb4a7b093b4', 'cncan', '2021-04-16 16:33:37');
INSERT INTO `sys_captcha` VALUES ('71438bc19027491883dc3e1db1e8af9c', 'nc5bp', '2021-04-10 15:00:40');
INSERT INTO `sys_captcha` VALUES ('7266079f58a342d4ad0b4ff00aaf179d', '56f2w', '2021-04-15 11:26:05');
INSERT INTO `sys_captcha` VALUES ('7269456bb43f4e9880af79d742cdb02a', '4ppy7', '2020-04-29 01:48:49');
INSERT INTO `sys_captcha` VALUES ('828859ab46b743f1abcbca4ac9cc0754', 'b8yxp', '2021-04-09 14:22:29');
INSERT INTO `sys_captcha` VALUES ('8d214c14882749f4ba0bbc40208616ae', 'n6dbp', '2021-04-14 15:38:43');
INSERT INTO `sys_captcha` VALUES ('8e799dced1c044a3a67336a00634161c', 'fn4dy', '2021-04-10 16:11:40');
INSERT INTO `sys_captcha` VALUES ('904187a8455e42f392b04b5a61603a08', 'pxmwp', '2021-04-10 15:25:10');
INSERT INTO `sys_captcha` VALUES ('975cfe89f9d24cde885efec52d3a6db2', 'f44m2', '2021-04-10 15:25:08');
INSERT INTO `sys_captcha` VALUES ('b1b778a269bd4e3c9f0239beb92582ea', 'cywfp', '2021-04-14 10:43:42');
INSERT INTO `sys_captcha` VALUES ('b9c4c98c1afb4b04a75fcc5c57bfa20b', 'b75d2', '2021-04-14 16:33:45');
INSERT INTO `sys_captcha` VALUES ('bd0e664e488a4eb9ad1572c96aeddd6c', 'ncdew', '2021-04-10 15:00:30');
INSERT INTO `sys_captcha` VALUES ('c2dbb328475643e7b6a7b71572245bcf', 'xc7gw', '2020-04-29 01:46:49');
INSERT INTO `sys_captcha` VALUES ('c9fa1b9cdfbe4a19bde5cb72e816c60d', 'xnfxg', '2021-04-15 10:44:19');
INSERT INTO `sys_captcha` VALUES ('cc49a9b71841448ca5f1b542a4ce47da', 'nx87m', '2021-04-14 15:39:53');
INSERT INTO `sys_captcha` VALUES ('d38e7c227ad649bab26c2d36a10035da', '2mfdd', '2021-04-10 11:59:33');
INSERT INTO `sys_captcha` VALUES ('d929e794517c4d99b3abbf9d8c9ee15b', '5camd', '2021-04-14 15:55:21');
INSERT INTO `sys_captcha` VALUES ('dce8fe021d064c89adc6e855493ef170', '28gm6', '2021-04-15 11:26:24');
INSERT INTO `sys_captcha` VALUES ('de0eee9b26024b6ca6c339d04b08dac8', 'ad7yf', '2021-04-10 15:04:14');
INSERT INTO `sys_captcha` VALUES ('e6c62dab89314492b2fba119405e71f7', '342nc', '2021-04-14 10:43:51');
INSERT INTO `sys_captcha` VALUES ('ec3f0fd424114a7bb082569cedc66da3', 'wpy5m', '2021-04-14 15:53:10');
INSERT INTO `sys_captcha` VALUES ('ed90eb75088341869dfe0d83e00da8d9', 'n84g8', '2021-04-16 15:28:24');
INSERT INTO `sys_captcha` VALUES ('ee141dcd4b5c47829099f90be35308b8', 'p4cba', '2021-04-16 09:28:24');
INSERT INTO `sys_captcha` VALUES ('f3afdc7410b04cd08f9c661fc437aaeb', 'ya64c', '2021-04-10 11:59:42');
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
                              `id` bigint(20) NOT NULL AUTO_INCREMENT,
                              `param_type` varchar(50) DEFAULT NULL COMMENT '系统内置: Y N ',
                              `param_key` varchar(50) DEFAULT NULL COMMENT 'key',
                              `param_value` varchar(255) DEFAULT NULL COMMENT 'value',
                              `param_name` varchar(2000) DEFAULT NULL COMMENT 'name',
                              `status` char(1) DEFAULT '0' COMMENT '状态   0：禁用   1：启用',
                              `remark` varchar(500) DEFAULT NULL COMMENT '备注',
                              `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                              `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                              `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                              PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='系统配置信息表/枚举值表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, 'Y', 'sys.index.skinName', 'skin-blue', '主框架页-默认皮肤样式名称', '1', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow\r', '2020-04-28 10:42:34', '2020-04-28 10:42:34', 1);
INSERT INTO `sys_config` VALUES (2, 'Y', 'sys.user.initPassword', '123456', '用户管理-账号初始密码', '1', '初始化密码 123456\r', '2020-04-28 10:42:34', '2020-04-28 10:42:34', 1);
INSERT INTO `sys_config` VALUES (3, 'Y', 'sys.index.sideTheme', 'theme-dark', '主框架页-侧边栏主题', '1', '深色主题theme-dark，浅色主题theme-light', '2020-04-28 10:42:34', '2020-04-28 10:42:34', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
                            `id` bigint(20) NOT NULL AUTO_INCREMENT,
                            `pid` bigint(20) NOT NULL COMMENT '上级部门',
                            `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表',
                            `name` varchar(100) DEFAULT NULL COMMENT '名称',
                            `sort` int(4) DEFAULT '0' COMMENT '排序',
                            `leader` varchar(20) DEFAULT NULL COMMENT '负责人',
                            `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
                            `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
                            `status` char(1) DEFAULT '1' COMMENT '启用状态：0->禁用；1->启用',
                            `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                            `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                            `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, 0, '0', 'Harry技术', 0, 'Harry', '17777777777', 'honghh1217@163.com', '1', '2020-04-14 17:25:45', '2020-04-14 17:25:45', 1);
INSERT INTO `sys_dept` VALUES (2, 1, '0,1', '研发部', 0, 'yanfa', '18888888888', '188@163.com', '1', '2020-04-14 17:38:23', '2020-04-14 17:38:23', 1);
INSERT INTO `sys_dept` VALUES (3, 4, '0,1,4', '营销A组', 1, NULL, NULL, NULL, '0', '2020-04-27 17:27:30', '2020-04-29 11:18:23', 1);
INSERT INTO `sys_dept` VALUES (4, 1, '0,1', '营销部', 1, 'ahah', '17777777377', NULL, '1', '2020-04-29 09:39:44', '2020-04-29 11:18:15', 1);
INSERT INTO `sys_dept` VALUES (5, 1, '0,1', '产品部', 1, '张三', NULL, NULL, '1', '2020-04-29 09:40:14', '2020-04-29 11:18:31', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
                            `id` bigint(11) NOT NULL AUTO_INCREMENT,
                            `name` varchar(255) NOT NULL COMMENT '字典名称',
                            `type` varchar(255) NOT NULL COMMENT '字典类型',
                            `status` char(1) DEFAULT NULL COMMENT '状态（1正常 0停用）',
                            `remark` varchar(255) DEFAULT NULL COMMENT '描述',
                            `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                            `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                            `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                            PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='数据字典';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES (1, '用户性别', 'sys_user_sex', '1', '用户性别', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (2, '菜单状态', 'sys_show_hide', '1', '菜单状态', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (3, '系统开关', 'sys_normal_disable', '1', '系统开关', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (4, '任务状态', 'sys_job_status', '1', '任务状态', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (5, '任务分组', 'sys_job_group', '1', '任务分组', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (6, '系统是否', 'sys_yes_no', '1', '系统是否', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (7, '通知类型', 'sys_notice_type', '1', '通知类型', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (8, '通知状态', 'sys_notice_status', '1', '通知状态', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (9, '操作类型', 'sys_oper_type', '1', '操作类型', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (10, '系统状态', 'sys_common_status', '1', '系统状态', '2020-04-27 15:18:28', '2020-04-27 15:18:28', 1);
INSERT INTO `sys_dict` VALUES (11, '用户岗位', 'sys_user_post', '1', '用户岗位', '2020-04-27 15:23:28', '2020-04-27 15:23:28', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_detail`;
CREATE TABLE `sys_dict_detail` (
                                   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
                                   `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
                                   `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
                                   `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
                                   `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
                                   `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
                                   `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
                                   `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
                                   `status` char(1) DEFAULT '1' COMMENT '状态（1正常 0停用）',
                                   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                   `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                   `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_detail
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_detail` VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (4, 1, '显示', '1', 'sys_show_hide', '', 'primary', 'Y', '1', '2020-04-27 15:20:24', '2020-04-29 08:43:48', 1);
INSERT INTO `sys_dict_detail` VALUES (5, 2, '隐藏', '0', 'sys_show_hide', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-29 08:43:50', 1);
INSERT INTO `sys_dict_detail` VALUES (6, 1, '正常', '1', 'sys_normal_disable', '', 'primary', 'Y', '1', '2020-04-27 15:20:24', '2020-04-29 08:43:59', 1);
INSERT INTO `sys_dict_detail` VALUES (7, 2, '停用', '0', 'sys_normal_disable', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-29 08:43:37', 1);
INSERT INTO `sys_dict_detail` VALUES (8, 1, '正常', '1', 'sys_job_status', '', 'primary', 'Y', '1', '2020-04-27 15:20:24', '2020-04-29 08:43:39', 1);
INSERT INTO `sys_dict_detail` VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-27 15:20:24', 1);
INSERT INTO `sys_dict_detail` VALUES (27, 1, '成功', '1', 'sys_common_status', '', 'primary', 'N', '1', '2020-04-27 15:20:24', '2020-04-29 09:31:30', 1);
INSERT INTO `sys_dict_detail` VALUES (28, 2, '失败', '0', 'sys_common_status', '', 'danger', 'N', '1', '2020-04-27 15:20:24', '2020-04-29 09:31:31', 1);
INSERT INTO `sys_dict_detail` VALUES (29, 1, '董事长', '1', 'sys_user_post', NULL, NULL, 'N', '1', '2020-04-27 15:24:27', '2020-04-27 15:24:27', 1);
INSERT INTO `sys_dict_detail` VALUES (30, 2, '项目经理', '2', 'sys_user_post', NULL, NULL, 'N', '1', '2020-04-27 15:24:52', '2020-04-27 15:25:33', 1);
INSERT INTO `sys_dict_detail` VALUES (31, 3, '人力资源', '3', 'sys_user_post', NULL, NULL, 'N', '1', '2020-04-27 15:24:57', '2020-04-27 15:25:33', 1);
INSERT INTO `sys_dict_detail` VALUES (32, 4, '产品经理', '4', 'sys_user_post', NULL, NULL, 'N', '1', '2020-04-27 15:24:58', '2020-04-27 15:26:12', 1);
INSERT INTO `sys_dict_detail` VALUES (33, 5, '普通员工', '5', 'sys_user_post', NULL, NULL, 'Y', '1', '2020-04-27 15:25:56', '2020-04-27 15:26:34', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
                            `id` bigint(20) NOT NULL AUTO_INCREMENT,
                            `pid` bigint(20) DEFAULT NULL COMMENT '父级权限id',
                            `name` varchar(100) DEFAULT NULL COMMENT '名称',
                            `value` varchar(200) DEFAULT NULL COMMENT '权限值',
                            `icon` varchar(500) DEFAULT NULL COMMENT '图标',
                            `type` int(1) DEFAULT NULL COMMENT '权限类型：0->目录；1->菜单；2->按钮（接口绑定权限）',
                            `uri` varchar(200) DEFAULT NULL COMMENT '前端资源路径',
                            `sort` int(11) DEFAULT NULL COMMENT '排序',
                            `outer_link` int(1) DEFAULT '0' COMMENT '是否为外链（1 是 0否）',
                            `path` varchar(255) DEFAULT NULL COMMENT '路由地址',
                            `status` char(1) DEFAULT NULL COMMENT '启用状态；0->禁用；1->启用',
                            `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1092 DEFAULT CHARSET=utf8mb4 COMMENT='后台用户权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', '', 'system', 0, '', 1, 0, 'system', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (2, 0, '系统监控', '', 'monitor', 0, '', 2, 0, 'monitor', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (3, 0, '系统工具', '', 'tool', 0, '', 3, 0, 'tool', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (4, 0, 'Harry官网', '', 'guide', 0, '', 4, 1, 'http://honghh.top', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (5, 0, '公众号管理', NULL, 'wechat', 0, NULL, 1, 0, 'wx', '1', '2021-04-09 09:58:20');
INSERT INTO `sys_menu` VALUES (100, 1, '用户管理', 'system:user:list', 'user', 1, 'system/user/index', 1, 0, 'user', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (101, 1, '角色管理', 'system:role:list', 'peoples', 1, 'system/role/index', 2, 0, 'role', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (102, 1, '菜单管理', 'system:menu:list', 'tree-table', 1, 'system/menu/index', 3, 0, 'menu', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (103, 1, '部门管理', 'system:dept:list', 'tree', 1, 'system/dept/index', 4, 0, 'dept', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (105, 1, '字典管理', 'system:dict:list', 'dict', 1, 'system/dict/index', 6, 0, 'dict', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (106, 1, '参数设置', 'system:config:list', 'edit', 1, 'system/config/index', 7, 0, 'config', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (108, 1, '日志管理', '', 'log', 0, 'system/log/index', 9, 0, 'log', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (109, 2, '在线用户', 'monitor:online:list', 'online', 1, 'monitor/online/index', 1, 0, 'online', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (113, 3, '表单构建', 'tool:build:list', 'build', 1, 'tool/build/index', 1, 0, 'build', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (114, 3, '代码生成', 'tool:gen:list', 'code', 1, 'tool/gen/index', 2, 0, 'gen', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (115, 3, '系统接口', 'tool:swagger:list', 'swagger', 1, 'tool/swagger/index', 3, 0, 'swagger', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (120, 5, '公众号菜单', 'wx:menu:list', NULL, 1, 'wx/menu/index', 2, 0, 'menu', '1', '2021-04-09 09:59:19');
INSERT INTO `sys_menu` VALUES (121, 5, '素材管理', 'wx:assets:list', NULL, 1, 'wx/assets/index', 2, 0, 'assets', '1', '2021-04-09 10:37:27');
INSERT INTO `sys_menu` VALUES (122, 5, '公众号账号', 'wx:account:list', NULL, 1, 'wx/account/index', 1, 0, 'account', '1', '2021-04-09 15:03:32');
INSERT INTO `sys_menu` VALUES (123, 5, '自动回复规则', 'wx:replyrule:list', NULL, 1, 'wx/replyrule/index', 1, 0, 'replyrule', '1', '2021-04-09 16:49:56');
INSERT INTO `sys_menu` VALUES (124, 5, '模板消息', 'wx:msgtemplate:list', NULL, 1, 'wx/msgtemplate/index', 1, 0, 'msgtemplate', '1', '2021-04-10 11:03:16');
INSERT INTO `sys_menu` VALUES (125, 5, '带参二维码', 'wx:qrcode:list', NULL, 1, 'wx/qrcode/index', 1, 0, 'qrcode', '1', '2021-04-10 15:01:06');
INSERT INTO `sys_menu` VALUES (126, 5, '粉丝管理', 'wx:wxuser:list', NULL, 1, 'wx/wxuser/index', 1, 0, 'wxuser', '1', '2021-04-10 15:29:19');
INSERT INTO `sys_menu` VALUES (500, 108, '操作日志', 'monitor:operlog:list', 'form', 1, 'monitor/operlog/index', 1, 0, 'operlog', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (501, 108, '登录日志', 'monitor:logininfor:list', 'logininfor', 1, 'monitor/logininfor/index', 2, 0, 'logininfor', '1', '2020-04-27 14:37:37');
INSERT INTO `sys_menu` VALUES (1001, 100, '用户查询', 'system:user:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1002, 100, '用户新增', 'system:user:add', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1003, 100, '用户修改', 'system:user:edit', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1004, 100, '用户删除', 'system:user:remove', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1005, 100, '用户导出', 'system:user:export', '', 2, '', 5, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1006, 100, '用户导入', 'system:user:import', '', 2, '', 6, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1007, 100, '重置密码', 'system:user:resetPwd', '', 2, '', 7, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1008, 101, '角色查询', 'system:role:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1009, 101, '角色新增', 'system:role:add', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1010, 101, '角色修改', 'system:role:edit', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1011, 101, '角色删除', 'system:role:remove', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1012, 101, '角色导出', 'system:role:export', '', 2, '', 5, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1013, 102, '菜单查询', 'system:menu:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1014, 102, '菜单新增', 'system:menu:add', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1015, 102, '菜单修改', 'system:menu:edit', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1016, 102, '菜单删除', 'system:menu:remove', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1017, 103, '部门查询', 'system:dept:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1018, 103, '部门新增', 'system:dept:add', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1019, 103, '部门修改', 'system:dept:edit', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1020, 103, '部门删除', 'system:dept:remove', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1021, 104, '岗位查询', 'system:post:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1022, 104, '岗位新增', 'system:post:add', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1023, 104, '岗位修改', 'system:post:edit', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1024, 104, '岗位删除', 'system:post:remove', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1025, 104, '岗位导出', 'system:post:export', '', 2, '', 5, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1026, 105, '字典查询', 'system:dict:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1027, 105, '字典新增', 'system:dict:add', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1028, 105, '字典修改', 'system:dict:edit', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1029, 105, '字典删除', 'system:dict:remove', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1030, 105, '字典导出', 'system:dict:export', '', 2, '', 5, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1031, 106, '参数查询', 'system:config:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1032, 106, '参数新增', 'system:config:add', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1033, 106, '参数修改', 'system:config:edit', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1034, 106, '参数删除', 'system:config:remove', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1035, 106, '参数导出', 'system:config:export', '', 2, '', 5, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1040, 500, '操作查询', 'monitor:operlog:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1041, 500, '操作删除', 'monitor:operlog:remove', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1042, 500, '日志导出', 'monitor:operlog:export', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1043, 501, '登录查询', 'monitor:logininfor:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1044, 501, '登录删除', 'monitor:logininfor:remove', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1045, 501, '日志导出', 'monitor:logininfor:export', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1046, 109, '在线查询', 'monitor:online:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1047, 109, '批量强退', 'monitor:online:batchLogout', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1048, 109, '单条强退', 'monitor:online:forceLogout', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1055, 114, '生成查询', 'tool:gen:query', '', 2, '', 1, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1056, 114, '生成修改', 'tool:gen:edit', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1057, 114, '生成删除', 'tool:gen:remove', '', 2, '', 3, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1058, 114, '导入代码', 'tool:gen:import', '', 2, '', 2, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1059, 114, '预览代码', 'tool:gen:preview', '', 2, '', 4, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1060, 114, '生成代码', 'tool:gen:code', '', 2, '', 5, 0, '', '1', '2020-04-28 16:42:10');
INSERT INTO `sys_menu` VALUES (1063, 120, '保存', 'wx:menu:save', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1065, 121, '保存', 'wx:assets:save', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1066, 121, '删除', 'wx:assets:remove', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1068, 122, '保存', 'wx:account:add', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1069, 122, '删除', 'wx:account:remove', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1070, 122, '修改', 'wx:account:edit', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1071, 122, '查询', 'wx:account:query', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1073, 123, '查询', 'wx:replyrule:query', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1074, 123, '修改', 'wx:replyrule:edit', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1075, 123, '添加', 'wx:replyrule:add', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1076, 123, '删除', 'wx:replyrule:remove', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1078, 124, '查询', 'wx:msgtemplate:query', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1079, 124, '修改', 'wx:msgtemplate:edit', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1080, 124, '添加', 'wx:msgtemplate:add', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1081, 124, '删除', 'wx:msgtemplate:remove', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1083, 125, '查询', 'wx:qrcode:query', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1084, 125, '修改', 'wx:qrcode:edit', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1085, 125, '添加', 'wx:qrcode:add', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1086, 125, '删除', 'wx:qrcode:remove', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1088, 126, '查询', 'wx:wxuser:query', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1089, 126, '修改', 'wx:wxuser:edit', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1090, 126, '添加', 'wx:wxuser:add', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
INSERT INTO `sys_menu` VALUES (1091, 126, '删除', 'wx:wxuser:remove', NULL, 2, NULL, 1, 0, NULL, NULL, '2021-04-09 10:22:02');
COMMIT;

-- ----------------------------
-- Table structure for sys_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation_log`;
CREATE TABLE `sys_operation_log` (
                                     `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
                                     `title` varchar(50) DEFAULT '' COMMENT '模块标题',
                                     `business_type` int(2) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
                                     `method` varchar(100) DEFAULT '' COMMENT '方法名称',
                                     `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
                                     `operator_type` int(1) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
                                     `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
                                     `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
                                     `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
                                     `oper_ip` varchar(50) DEFAULT '' COMMENT '主机地址',
                                     `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
                                     `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
                                     `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数',
                                     `status` char(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
                                     `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
                                     `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                     `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                     `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志记录';

-- ----------------------------
-- Records of sys_operation_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_operation_log` VALUES (5, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '192.168.1.222', '内网IP', '{\"icon\":\"wechat\",\"pid\":0,\"sort\":1,\"type\":0,\"path\":\"/mp\",\"children\":[],\"name\":\"公众号管理\",\"outerLink\":\"0\",\"id\":1061,\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 09:58:20', '2021-04-09 09:58:20', 1);
INSERT INTO `sys_operation_log` VALUES (6, '菜单管理', 2, 'cn.harry.controller.sys.SysMenuController.update()', 'PUT', 0, 'admin', '', '/sys/menu/update/1061', '192.168.1.222', '内网IP', '1061 {\"icon\":\"wechat\",\"pid\":0,\"sort\":1,\"type\":0,\"path\":\"wx\",\"children\":[],\"createTime\":1617933500000,\"name\":\"公众号管理\",\"outerLink\":\"0\",\"id\":1061,\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 09:58:34', '2021-04-09 09:58:34', 1);
INSERT INTO `sys_operation_log` VALUES (7, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '192.168.1.222', '内网IP', '{\"pid\":1061,\"sort\":1,\"type\":1,\"uri\":\"/mp/menu/index\",\"path\":\"menu\",\"children\":[],\"name\":\"公众号菜单\",\"outerLink\":\"0\",\"id\":1062,\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 09:59:19', '2021-04-09 09:59:19', 1);
INSERT INTO `sys_operation_log` VALUES (8, '菜单管理', 2, 'cn.harry.controller.sys.SysMenuController.update()', 'PUT', 0, 'admin', '', '/sys/menu/update/1062', '192.168.1.222', '内网IP', '1062 {\"pid\":1061,\"sort\":1,\"type\":1,\"uri\":\"mx/menu/index\",\"path\":\"menu\",\"children\":[],\"createTime\":1617933559000,\"name\":\"公众号菜单\",\"outerLink\":\"0\",\"id\":1062,\"value\":\"wx:menu:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 09:59:51', '2021-04-09 09:59:51', 1);
INSERT INTO `sys_operation_log` VALUES (9, '菜单管理', 2, 'cn.harry.controller.sys.SysMenuController.update()', 'PUT', 0, 'admin', '', '/sys/menu/update/1062', '192.168.1.222', '内网IP', '1062 {\"pid\":1061,\"sort\":1,\"type\":1,\"uri\":\"wx/menu/index\",\"path\":\"menu\",\"children\":[],\"createTime\":1617933559000,\"name\":\"公众号菜单\",\"outerLink\":\"0\",\"id\":1062,\"value\":\"wx:menu:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 10:00:02', '2021-04-09 10:00:02', 1);
INSERT INTO `sys_operation_log` VALUES (10, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '192.168.1.222', '内网IP', '{\"pid\":1062,\"sort\":1,\"type\":2,\"children\":[],\"name\":\"保存\",\"outerLink\":\"0\",\"id\":1063,\"value\":\"wx:menu:save\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 10:22:02', '2021-04-09 10:22:02', 1);
INSERT INTO `sys_operation_log` VALUES (11, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '192.168.1.222', '内网IP', '{\"pid\":5,\"sort\":1,\"type\":1,\"uri\":\"wx/assets/index\",\"path\":\"assets\",\"children\":[],\"name\":\"素材管理\",\"outerLink\":\"0\",\"id\":1064,\"value\":\"wx:assets:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 10:37:27', '2021-04-09 10:37:27', 1);
INSERT INTO `sys_operation_log` VALUES (12, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '192.168.1.222', '内网IP', '{\"pid\":5,\"sort\":1,\"type\":1,\"uri\":\"wx/account/index\",\"path\":\"account\",\"children\":[],\"name\":\"公众号账号\",\"outerLink\":\"0\",\"id\":1067,\"value\":\"wx:account:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 15:03:33', '2021-04-09 15:03:33', 1);
INSERT INTO `sys_operation_log` VALUES (13, '公众号账号类型', 3, 'cn.harry.controller.wx.WxAccountController.deleteByIds()', 'DELETE', 0, 'admin', '', '/wx/account/deleteByIds/1', '192.168.1.222', '内网IP', '{ids=1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 16:13:58', '2021-04-09 16:13:58', 1);
INSERT INTO `sys_operation_log` VALUES (14, '公众号账号类型', 3, 'cn.harry.controller.wx.WxAccountController.deleteByIds()', 'DELETE', 0, 'admin', '', '/wx/account/deleteByIds/1', '192.168.1.222', '内网IP', '{ids=1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 16:16:17', '2021-04-09 16:16:17', 1);
INSERT INTO `sys_operation_log` VALUES (15, '公众号账号数据', 2, 'cn.harry.controller.wx.WxAccountController.update()', 'PUT', 0, 'admin', '', '/wx/account/update/1', '192.168.1.222', '内网IP', '1 {\"verified\":true,\"secret\":\"ba0cbb36fca3e699156fd157fbd4015e\",\"type\":2,\"token\":\"juzicpscom\",\"valid\":1,\"modifyTime\":1617956223000,\"createTime\":1617874148000,\"appid\":\"wx056e868bb428ae64\",\"name\":\"测试账号\",\"aesKey\":\"owrObkVaGjCpMWlzEF9VFKWakkoY6I70zNtXCxUeskS\",\"id\":1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 16:19:06', '2021-04-09 16:19:06', 1);
INSERT INTO `sys_operation_log` VALUES (16, '公众号账号数据', 2, 'cn.harry.controller.wx.WxAccountController.update()', 'PUT', 0, 'admin', '', '/wx/account/update/1', '192.168.1.222', '内网IP', '1 {\"verified\":\"0\",\"secret\":\"ba0cbb36fca3e699156fd157fbd4015e\",\"type\":2,\"token\":\"juzicpscom\",\"valid\":1,\"modifyTime\":1617956223000,\"createTime\":1617874148000,\"appid\":\"wx056e868bb428ae64\",\"name\":\"测试账号\",\"aesKey\":\"owrObkVaGjCpMWlzEF9VFKWakkoY6I70zNtXCxUeskS\",\"id\":1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 16:28:55', '2021-04-09 16:28:55', 1);
INSERT INTO `sys_operation_log` VALUES (17, '公众号账号数据', 2, 'cn.harry.controller.wx.WxAccountController.update()', 'PUT', 0, 'admin', '', '/wx/account/update/1', '192.168.1.222', '内网IP', '1 {\"verified\":\"1\",\"secret\":\"ba0cbb36fca3e699156fd157fbd4015e\",\"type\":1,\"token\":\"juzicpscom\",\"valid\":1,\"modifyTime\":1617956223000,\"createTime\":1617874148000,\"appid\":\"wx056e868bb428ae64\",\"name\":\"测试账号\",\"aesKey\":\"owrObkVaGjCpMWlzEF9VFKWakkoY6I70zNtXCxUeskS\",\"id\":1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 16:29:03', '2021-04-09 16:29:03', 1);
INSERT INTO `sys_operation_log` VALUES (18, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '192.168.1.222', '内网IP', '{\"pid\":5,\"sort\":1,\"type\":1,\"uri\":\"wx/replyrule/index\",\"path\":\"replyrule\",\"children\":[],\"name\":\"自动回复规则\",\"outerLink\":\"0\",\"id\":1072,\"value\":\"wx:replyrule:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-09 16:49:56', '2021-04-09 16:49:56', 1);
INSERT INTO `sys_operation_log` VALUES (19, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/2', '127.0.0.1', '内网IP', '2 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"10:24:52\",\"matchValue\":\"2,3\",\"priority\":0,\"effectTimeStart\":\"10:24:52\",\"valid\":1,\"modifyTime\":1618021565000,\"createTime\":1618021565000,\"appid\":\"\",\"ruleName\":\"1\",\"id\":2,\"replyContent\":\"媒体素材media_id\",\"desc\":\"1\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 10:27:08', '2021-04-10 10:27:08', 1);
INSERT INTO `sys_operation_log` VALUES (20, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '127.0.0.1', '内网IP', '{\"pid\":5,\"sort\":1,\"type\":1,\"uri\":\"wx/msgtemplate/index\",\"path\":\"msgtemplate\",\"children\":[],\"name\":\"模板消息\",\"outerLink\":\"0\",\"id\":1077,\"value\":\"wx:msgtemplate:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 11:03:16', '2021-04-10 11:03:16', 1);
INSERT INTO `sys_operation_log` VALUES (21, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '127.0.0.1', '内网IP', '{\"pid\":5,\"sort\":1,\"type\":1,\"uri\":\"wx/qrcode/index\",\"path\":\"qrcode\",\"children\":[],\"name\":\"带参二维码\",\"outerLink\":\"0\",\"id\":1082,\"value\":\"wx:qrcode:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 15:01:07', '2021-04-10 15:01:07', 1);
INSERT INTO `sys_operation_log` VALUES (22, '公众号带参二维码数据', 2, 'cn.harry.controller.wx.WxQrCodeController.update()', 'PUT', 0, 'admin', '', '/wx/qrcode/update/1', '127.0.0.1', '内网IP', '1 {\"temp\":true,\"sceneStr\":\"1\",\"ticket\":\"gQEY7jwAAAAAAAAAAS5odHRwOi8vd2VpeGluLnFxLmNvbS9xLzAyNFhFdWRjSnNkeEcxbWVoTnh3Y2kAAgRSUXFgAwQ8AAAA\",\"url\":\"http://weixin.qq.com/q/024XEudcJsdxG1mehNxwci\",\"valid\":1,\"expireTime\":1618039182000,\"modifyTime\":1618039123000,\"createTime\":1618039122000,\"appid\":\"wx056e868bb428ae64\",\"id\":1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 15:22:56', '2021-04-10 15:22:56', 1);
INSERT INTO `sys_operation_log` VALUES (23, '公众号带参二维码数据', 2, 'cn.harry.controller.wx.WxQrCodeController.update()', 'PUT', 0, 'admin', '', '/wx/qrcode/update/1', '127.0.0.1', '内网IP', '1 {\"temp\":true,\"sceneStr\":\"1\",\"ticket\":\"gQEY7jwAAAAAAAAAAS5odHRwOi8vd2VpeGluLnFxLmNvbS9xLzAyNFhFdWRjSnNkeEcxbWVoTnh3Y2kAAgRSUXFgAwQ8AAAA\",\"url\":\"http://weixin.qq.com/q/024XEudcJsdxG1mehNxwci\",\"valid\":1,\"expireTime\":1618039182000,\"modifyTime\":1618039123000,\"createTime\":1618039122000,\"appid\":\"wx056e868bb428ae64\",\"id\":1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 15:23:22', '2021-04-10 15:23:22', 1);
INSERT INTO `sys_operation_log` VALUES (24, '公众号带参二维码数据', 2, 'cn.harry.controller.wx.WxQrCodeController.update()', 'PUT', 0, 'admin', '', '/wx/qrcode/update/1', '127.0.0.1', '内网IP', '1 {\"temp\":true,\"sceneStr\":\"1\",\"ticket\":\"gQEY7jwAAAAAAAAAAS5odHRwOi8vd2VpeGluLnFxLmNvbS9xLzAyNFhFdWRjSnNkeEcxbWVoTnh3Y2kAAgRSUXFgAwQ8AAAA\",\"url\":\"http://weixin.qq.com/q/024XEudcJsdxG1mehNxwci\",\"valid\":1,\"expireTime\":1618039182000,\"modifyTime\":1618039123000,\"createTime\":1618039122000,\"appid\":\"wx056e868bb428ae64\",\"id\":1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 15:23:38', '2021-04-10 15:23:38', 1);
INSERT INTO `sys_operation_log` VALUES (25, '菜单管理', 1, 'cn.harry.controller.sys.SysMenuController.create()', 'POST', 0, 'admin', '', '/sys/menu/create', '127.0.0.1', '内网IP', '{\"pid\":5,\"sort\":1,\"type\":1,\"uri\":\"wx/user/index\",\"path\":\"user\",\"children\":[],\"name\":\"粉丝管理\",\"outerLink\":\"0\",\"id\":1087,\"value\":\"wx:user:index\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 15:29:19', '2021-04-10 15:29:19', 1);
INSERT INTO `sys_operation_log` VALUES (26, '菜单管理', 2, 'cn.harry.controller.sys.SysMenuController.update()', 'PUT', 0, 'admin', '', '/sys/menu/update/126', '127.0.0.1', '内网IP', '126 {\"pid\":5,\"sort\":1,\"type\":1,\"uri\":\"wx/wxuser/index\",\"path\":\"wxuser\",\"children\":[],\"createTime\":1618039759000,\"name\":\"粉丝管理\",\"outerLink\":\"0\",\"id\":126,\"value\":\"wx:wxuser:index\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 15:35:20', '2021-04-10 15:35:20', 1);
INSERT INTO `sys_operation_log` VALUES (27, '公众号账号数据', 2, 'cn.harry.controller.wx.WxAccountController.update()', 'PUT', 0, 'admin', '', '/wx/account/update/1', '127.0.0.1', '内网IP', '1 {\"verified\":\"1\",\"secret\":\"ba0cbb36fca3e699156fd157fbd4015e\",\"type\":1,\"token\":\"juzicpscom\",\"valid\":1,\"modifyTime\":1617956223000,\"createTime\":1617874148000,\"appid\":\"wx056e868bb428ae64\",\"name\":\"测试账号\",\"aesKey\":\"\",\"id\":1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-10 16:33:38', '2021-04-10 16:33:38', 1);
INSERT INTO `sys_operation_log` VALUES (28, '用户表类型', 3, 'cn.harry.controller.wx.WxUserController.deleteByIds()', 'DELETE', 0, 'admin', '', '/wx/wxuser/deleteByIds/3', '192.168.1.222', '内网IP', '{ids=3}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-13 11:28:42', '2021-04-13 11:28:42', 1);
INSERT INTO `sys_operation_log` VALUES (29, '用户表类型', 3, 'cn.harry.controller.wx.WxUserController.deleteByIds()', 'DELETE', 0, 'admin', '', '/wx/wxuser/deleteByIds/2', '192.168.1.222', '内网IP', '{ids=2}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-13 11:28:44', '2021-04-13 11:28:44', 1);
INSERT INTO `sys_operation_log` VALUES (30, '用户表类型', 3, 'cn.harry.controller.wx.WxUserController.deleteByIds()', 'DELETE', 0, 'admin', '', '/wx/wxuser/deleteByIds/1', '192.168.1.222', '内网IP', '{ids=1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-13 11:28:46', '2021-04-13 11:28:46', 1);
INSERT INTO `sys_operation_log` VALUES (31, '用户表类型', 3, 'cn.harry.controller.wx.WxUserController.deleteByIds()', 'DELETE', 0, 'admin', '', '/wx/wxuser/deleteByIds/6', '192.168.1.222', '内网IP', '{ids=6}', '{\"code\":500,\"message\":\"操作失败\"}', '1', '', '2021-04-13 11:37:04', '2021-04-13 11:37:04', 1);
INSERT INTO `sys_operation_log` VALUES (32, '用户表类型', 3, 'cn.harry.controller.wx.WxUserController.deleteByIds()', 'DELETE', 0, 'admin', '', '/wx/wxuser/deleteByIds/o7Rxh6jG0D9MdIUMakOfYZTCQuHk', '192.168.1.222', '内网IP', '{ids=o7Rxh6jG0D9MdIUMakOfYZTCQuHk}', '{\"code\":200,\"data\":3,\"message\":\"操作成功\"}', '1', '', '2021-04-13 11:41:04', '2021-04-13 11:41:04', 1);
INSERT INTO `sys_operation_log` VALUES (33, '用户表类型', 3, 'cn.harry.controller.wx.WxUserController.deleteByIds()', 'DELETE', 0, 'admin', '', '/wx/wxuser/deleteByIds/o7Rxh6jG0D9MdIUMakOfYZTCQuHk', '192.168.1.222', '内网IP', '{ids=o7Rxh6jG0D9MdIUMakOfYZTCQuHk}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-13 11:41:16', '2021-04-13 11:41:16', 1);
INSERT INTO `sys_operation_log` VALUES (34, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/2', '192.168.1.222', '内网IP', '2 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"10:24:52\",\"matchValue\":\"2,3\",\"priority\":0,\"effectTimeStart\":\"10:24:52\",\"valid\":1,\"modifyTime\":1618021565000,\"createTime\":1618021565000,\"appid\":\"\",\"ruleName\":\"1\",\"id\":2,\"replyContent\":\"媒体素材media_id<a href=\\\"链接地址\\\">链接文字</a>\",\"desc\":\"1\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-13 17:25:26', '2021-04-13 17:25:26', 1);
INSERT INTO `sys_operation_log` VALUES (35, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/2', '192.168.1.222', '内网IP', '2 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"10:24:52\",\"matchValue\":\"2,3\",\"priority\":0,\"effectTimeStart\":\"10:24:52\",\"valid\":1,\"modifyTime\":1618021565000,\"createTime\":1618021565000,\"appid\":\"wx056e868bb428ae64\",\"ruleName\":\"1\",\"id\":2,\"replyContent\":\"媒体素材media_id<a href=\\\"链接地址\\\">链接文字</a>\",\"desc\":\"1\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-13 17:25:46', '2021-04-13 17:25:46', 1);
INSERT INTO `sys_operation_log` VALUES (36, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/2', '192.168.1.222', '内网IP', '2 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"23:59:52\",\"matchValue\":\"2,3\",\"priority\":0,\"effectTimeStart\":\"10:24:52\",\"valid\":1,\"modifyTime\":1618021565000,\"createTime\":1618021565000,\"appid\":\"wx056e868bb428ae64\",\"ruleName\":\"1\",\"id\":2,\"replyContent\":\"媒体素材media_id<a href=\\\"链接地址\\\">链接文字</a>\",\"desc\":\"1\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-13 17:25:59', '2021-04-13 17:25:59', 1);
INSERT INTO `sys_operation_log` VALUES (37, '用户管理', 2, 'cn.harry.controller.sys.SysUserController.update()', 'PUT', 0, 'admin', '', '/sys/user/update/101', '192.168.1.222', '内网IP', '101 {\"deptName\":\"研发部\",\"note\":\"assa的收到dfsd\",\"nickName\":\"Harry测试\",\"sex\":\"1\",\"deptId\":2,\"icon\":\"\",\"valid\":1,\"loginTime\":1569736539000,\"modifyTime\":1588140246000,\"roleIds\":[2],\"createTime\":1569736530000,\"phone\":\"17777777777\",\"postIds\":\"[\\\"2\\\"]\",\"id\":101,\"email\":\"183865800@qq.com\",\"status\":\"1\",\"username\":\"harry\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 15:33:11', '2021-04-14 15:33:11', 1);
INSERT INTO `sys_operation_log` VALUES (38, '角色管理', 2, 'cn.harry.controller.sys.SysRoleController.update()', 'PUT', 0, 'admin', '', '/sys/role/update/2', '192.168.1.222', '内网IP', '2 {\"description\":\"测试\",\"sort\":2,\"dataScope\":\"3\",\"createTime\":1582083863000,\"name\":\"测试\",\"roleKey\":\"test\",\"id\":2,\"menuIds\":[1001,1008,1013,1017,1026,1031,1040,1043,1046,5,120,1063,121,1065,1066,122,1068,1069,1070,1071,123,1073,1074,1075,1076,124,1078,1079,1080,1081,125,1083,1084,1085,1086,126,1088,1089,1090,1091,1,100,101,102,103,105,106,108,500,501,2,109],\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 15:33:33', '2021-04-14 15:33:33', 1);
INSERT INTO `sys_operation_log` VALUES (39, '菜单管理', 2, 'cn.harry.controller.sys.SysMenuController.update()', 'PUT', 0, 'admin', '', '/sys/menu/update/121', '192.168.1.222', '内网IP', '121 {\"pid\":5,\"sort\":2,\"type\":1,\"uri\":\"wx/assets/index\",\"path\":\"assets\",\"children\":[],\"createTime\":1617935847000,\"name\":\"素材管理\",\"outerLink\":\"0\",\"id\":121,\"value\":\"wx:assets:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 15:49:00', '2021-04-14 15:49:00', 1);
INSERT INTO `sys_operation_log` VALUES (40, '菜单管理', 2, 'cn.harry.controller.sys.SysMenuController.update()', 'PUT', 0, 'admin', '', '/sys/menu/update/120', '192.168.1.222', '内网IP', '120 {\"pid\":5,\"sort\":2,\"type\":1,\"uri\":\"wx/menu/index\",\"path\":\"menu\",\"children\":[],\"createTime\":1617933559000,\"name\":\"公众号菜单\",\"outerLink\":\"0\",\"id\":120,\"value\":\"wx:menu:list\",\"status\":\"1\"}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 15:49:08', '2021-04-14 15:49:08', 1);
INSERT INTO `sys_operation_log` VALUES (41, '公众号账号数据', 2, 'cn.harry.controller.wx.WxAccountController.update()', 'PUT', 0, 'harry', '', '/wx/account/update/3', '192.168.1.222', '内网IP', '3 {\"verified\":\"0\",\"secret\":\"54b9bf8896cfe6f8c18bd06904647131\",\"type\":2,\"userId\":101,\"token\":\"juzi\",\"valid\":1,\"modifyTime\":1618386905000,\"createTime\":1618386905000,\"appid\":\"wx708f13f6a1277e32\",\"name\":\"橘子的测试公众号\",\"id\":3}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 16:04:29', '2021-04-14 16:04:29', 1);
INSERT INTO `sys_operation_log` VALUES (42, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'harry', '', '/wx/replyrule/update/3', '192.168.1.222', '内网IP', '3 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"23:45:39\",\"matchValue\":\"hary\",\"priority\":0,\"userId\":101,\"effectTimeStart\":\"15:45:37\",\"valid\":1,\"modifyTime\":1618386347000,\"createTime\":1618386347000,\"appid\":\"\",\"ruleName\":\"harry\",\"id\":3,\"replyContent\":\"媒体素材media_id\",\"status\":false}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 16:07:36', '2021-04-14 16:07:36', 1);
INSERT INTO `sys_operation_log` VALUES (43, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'harry', '', '/wx/replyrule/update/3', '192.168.1.222', '内网IP', '3 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"23:45:39\",\"matchValue\":\"1\",\"priority\":0,\"userId\":101,\"effectTimeStart\":\"15:45:37\",\"valid\":1,\"modifyTime\":1618386347000,\"createTime\":1618386347000,\"appid\":\"wx708f13f6a1277e32\",\"ruleName\":\"harry\",\"id\":3,\"replyContent\":\"ahhashdasd\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 16:22:25', '2021-04-14 16:22:25', 1);
INSERT INTO `sys_operation_log` VALUES (44, '公众号账号数据', 2, 'cn.harry.controller.wx.WxAccountController.update()', 'PUT', 0, 'admin', '', '/wx/account/update/3', '192.168.1.222', '内网IP', '3 {\"verified\":\"1\",\"secret\":\"54b9bf8896cfe6f8c18bd06904647131\",\"type\":2,\"userId\":101,\"token\":\"juzi\",\"valid\":1,\"modifyTime\":1618386905000,\"createTime\":1618386905000,\"appid\":\"wx708f13f6a1277e32\",\"name\":\"橘子的测试公众号\",\"id\":3}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 17:00:16', '2021-04-14 17:00:16', 1);
INSERT INTO `sys_operation_log` VALUES (45, '公众号账号数据', 2, 'cn.harry.controller.wx.WxAccountController.update()', 'PUT', 0, 'admin', '', '/wx/account/update/1', '192.168.1.222', '内网IP', '1 {\"verified\":\"1\",\"secret\":\"ba0cbb36fca3e699156fd157fbd4015e\",\"type\":1,\"token\":\"juzicpscom\",\"valid\":1,\"modifyTime\":1617956223000,\"createTime\":1617874148000,\"appid\":\"wx056e868bb428ae64\",\"name\":\"kuaiwuqi测试账号\",\"aesKey\":\"\",\"id\":1}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-14 17:20:14', '2021-04-14 17:20:14', 1);
INSERT INTO `sys_operation_log` VALUES (46, '消息模板数据', 2, 'cn.harry.controller.wx.WxMsgTemplateController.update()', 'PUT', 0, 'admin', '', '/wx/msgtemplate/update/14', '192.168.1.222', '内网IP', '14 {\"data\":[{\"name\":\"first\",\"value\":\"服务至上\",\"color\":\"#000000\"},{\"name\":\"keyword1\",\"value\":\"按摩\",\"color\":\"#000000\"},{\"name\":\"keyword2\",\"value\":\"今天\",\"color\":\"#000000\"},{\"name\":\"remark\",\"value\":\"满分服务\",\"color\":\"#000000\"}],\"templateId\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"title\":\"服务\",\"content\":\"{{first.DATA}}\\n服务名称：{{keyword1.DATA}}\\n服务时间：{{keyword2.DATA}}\\n{{remark.DATA}}\",\"valid\":1,\"modifyTime\":1618475285000,\"createTime\":1618475285000,\"appid\":\"wx708f13f6a1277e32\",\"name\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"id\":14,\"miniprogram\":{\"appid\":\"\",\"pagePath\":\"\"},\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-15 16:29:06', '2021-04-15 16:29:06', 1);
INSERT INTO `sys_operation_log` VALUES (47, '消息模板数据', 2, 'cn.harry.controller.wx.WxMsgTemplateController.update()', 'PUT', 0, 'admin', '', '/wx/msgtemplate/update/14', '192.168.1.222', '内网IP', '14 {\"data\":[{\"color\":\"#000000\",\"name\":\"first\",\"value\":\"服务至上\"},{\"color\":\"#000000\",\"name\":\"keyword1\",\"value\":\"按摩\"},{\"color\":\"#000000\",\"name\":\"keyword2\",\"value\":\"今天\"},{\"color\":\"#000000\",\"name\":\"remark\",\"value\":\"满分服务\"}],\"templateId\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"title\":\"服务\",\"content\":\"{{first.DATA}}\\n服务名称：{{keyword1.DATA}}\\n服务时间：{{keyword2.DATA}}\\n{{remark.DATA}}\",\"url\":\"www.baidu.com\",\"valid\":1,\"modifyTime\":1618475285000,\"createTime\":1618475285000,\"appid\":\"wx708f13f6a1277e32\",\"name\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"id\":14,\"miniprogram\":{\"appid\":\"\",\"pagePath\":\"\"},\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-15 17:16:07', '2021-04-15 17:16:07', 1);
INSERT INTO `sys_operation_log` VALUES (48, '消息模板数据', 2, 'cn.harry.controller.wx.WxMsgTemplateController.update()', 'PUT', 0, 'admin', '', '/wx/msgtemplate/update/14', '192.168.1.222', '内网IP', '14 {\"data\":[{\"color\":\"#000000\",\"name\":\"first\",\"value\":\"服务至上\"},{\"color\":\"#000000\",\"name\":\"keyword1\",\"value\":\"按摩\"},{\"color\":\"#000000\",\"name\":\"keyword2\",\"value\":\"今天\"},{\"color\":\"#000000\",\"name\":\"remark\",\"value\":\"满分服务\"}],\"templateId\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"title\":\"服务\",\"content\":\"{{first.DATA}}\\n服务名称：{{keyword1.DATA}}\\n服务时间：{{keyword2.DATA}}\\n{{remark.DATA}}\",\"url\":\"www.baidu.com\",\"valid\":1,\"modifyTime\":1618475285000,\"createTime\":1618475285000,\"appid\":\"wx708f13f6a1277e32\",\"name\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"id\":14,\"miniprogram\":{\"appid\":\"www.baidu.com\",\"pagePath\":\"www.baidu.com\"},\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-15 17:17:06', '2021-04-15 17:17:06', 1);
INSERT INTO `sys_operation_log` VALUES (49, '消息模板数据', 2, 'cn.harry.controller.wx.WxMsgTemplateController.update()', 'PUT', 0, 'admin', '', '/wx/msgtemplate/update/14', '192.168.1.222', '内网IP', '14 {\"data\":[{\"color\":\"#9660fb\",\"name\":\"first\",\"value\":\"服务至上\"},{\"color\":\"#b91d1d\",\"name\":\"keyword1\",\"value\":\"按摩\"},{\"color\":\"#372a2a\",\"name\":\"keyword2\",\"value\":\"今天\"},{\"color\":\"#2f8b23\",\"name\":\"remark\",\"value\":\"满分服务\"}],\"templateId\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"title\":\"服务\",\"content\":\"{{first.DATA}}\\n服务名称：{{keyword1.DATA}}\\n服务时间：{{keyword2.DATA}}\\n{{remark.DATA}}\",\"url\":\"www.baidu.com\",\"valid\":1,\"modifyTime\":1618475285000,\"createTime\":1618475285000,\"appid\":\"wx708f13f6a1277e32\",\"name\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"id\":14,\"miniprogram\":{\"appid\":\"\",\"pagePath\":\"\"},\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-15 17:18:13', '2021-04-15 17:18:13', 1);
INSERT INTO `sys_operation_log` VALUES (50, '消息模板数据', 2, 'cn.harry.controller.wx.WxMsgTemplateController.update()', 'PUT', 0, 'admin', '', '/wx/msgtemplate/update/18', '192.168.1.222', '内网IP', '18 {\"data\":[{\"name\":\"first\",\"value\":\"哈哈哈\",\"color\":\"#000000\"},{\"name\":\"keyword1\",\"value\":\"和hi鹅hi恶化\",\"color\":\"#000000\"},{\"name\":\"keyword2\",\"value\":\"伤口撒开\",\"color\":\"#000000\"},{\"name\":\"remark\",\"value\":\"撒范德萨发\",\"color\":\"#000000\"}],\"templateId\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"title\":\"服务\",\"userId\":101,\"content\":\"{{first.DATA}}\\n服务名称：{{keyword1.DATA}}\\n服务时间：{{keyword2.DATA}}\\n{{remark.DATA}}\",\"valid\":1,\"modifyTime\":1618478881000,\"createTime\":1618478881000,\"appid\":\"wx708f13f6a1277e32\",\"name\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"id\":18,\"miniprogram\":{\"appid\":\"\",\"pagePath\":\"\"},\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-15 17:28:40', '2021-04-15 17:28:40', 1);
INSERT INTO `sys_operation_log` VALUES (51, '消息模板数据', 2, 'cn.harry.controller.wx.WxMsgTemplateController.update()', 'PUT', 0, 'admin', '', '/wx/msgtemplate/update/18', '192.168.1.222', '内网IP', '18 {\"data\":[{\"color\":\"#000000\",\"name\":\"first\",\"value\":\"一百周年庆典\"},{\"color\":\"#000000\",\"name\":\"keyword1\",\"value\":\"不忘初心，砥砺前行 牢记使命，不懈奋斗\"},{\"color\":\"#000000\",\"name\":\"keyword2\",\"value\":\"2021/7/1\"},{\"color\":\"#000000\",\"name\":\"remark\",\"value\":\"我们脚踏实地，你来天马行空，有好的想法就来找我们吧，实现你的情怀和梦想。\"}],\"templateId\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"title\":\"一百周年庆典\",\"userId\":101,\"content\":\"{{first.DATA}}\\n服务名称：{{keyword1.DATA}}\\n服务时间：{{keyword2.DATA}}\\n{{remark.DATA}}\",\"valid\":1,\"modifyTime\":1618478881000,\"createTime\":1618478881000,\"appid\":\"wx708f13f6a1277e32\",\"name\":\"834ZpxBCjvBke328zHYjMMc7pKYxv8E3jBBH7OoBWiM\",\"id\":18,\"miniprogram\":{\"appid\":\"\",\"pagePath\":\"\"},\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-16 09:29:26', '2021-04-16 09:29:26', 1);
INSERT INTO `sys_operation_log` VALUES (52, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/3', '192.168.1.222', '内网IP', '3 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"23:45:39\",\"matchValue\":\"1\",\"priority\":0,\"userId\":101,\"effectTimeStart\":\"15:45:37\",\"valid\":1,\"modifyTime\":1618386347000,\"createTime\":1618386347000,\"appid\":\"wx708f13f6a1277e32\",\"ruleName\":\"harry\",\"id\":3,\"replyContent\":\"ahhashdasd\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-16 15:31:52', '2021-04-16 15:31:52', 1);
INSERT INTO `sys_operation_log` VALUES (53, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/3', '192.168.1.222', '内网IP', '3 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"23:45:39\",\"matchValue\":\"1\",\"priority\":0,\"userId\":101,\"effectTimeStart\":\"00:00:00\",\"valid\":1,\"modifyTime\":1618386347000,\"createTime\":1618386347000,\"appid\":\"wx708f13f6a1277e32\",\"ruleName\":\"harry\",\"id\":3,\"replyContent\":\"ahhashdasd\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-16 15:34:02', '2021-04-16 15:34:02', 1);
INSERT INTO `sys_operation_log` VALUES (54, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/1', '192.168.1.222', '内网IP', '1 {\"replyType\":\"text\",\"exactMatch\":false,\"effectTimeEnd\":\"23:59:59\",\"matchValue\":\"subscribe\",\"priority\":0,\"effectTimeStart\":\"00:00:00\",\"valid\":1,\"modifyTime\":1618019630000,\"createTime\":1618019630000,\"appid\":\"wx708f13f6a1277e32\",\"ruleName\":\"关注公众号\",\"id\":1,\"replyContent\":\"你好，欢迎关注！\",\"desc\":\"关注回复\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-16 15:42:30', '2021-04-16 15:42:30', 1);
INSERT INTO `sys_operation_log` VALUES (55, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/2', '192.168.1.222', '内网IP', '2 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"23:59:52\",\"matchValue\":\"2,3\",\"priority\":0,\"effectTimeStart\":\"10:24:52\",\"valid\":1,\"modifyTime\":1618021565000,\"createTime\":1618021565000,\"appid\":\"wx056e868bb428ae64\",\"ruleName\":\"1\",\"id\":2,\"replyContent\":\"媒体素材media_id<a href=\\\"链接地址\\\">链接文字</a>\",\"desc\":\"1\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-16 15:46:36', '2021-04-16 15:46:36', 1);
INSERT INTO `sys_operation_log` VALUES (56, '自动回复规则数据', 2, 'cn.harry.controller.wx.WxMsgReplyRuleController.update()', 'PUT', 0, 'admin', '', '/wx/replyrule/update/2', '192.168.1.222', '内网IP', '2 {\"replyType\":\"text\",\"exactMatch\":true,\"effectTimeEnd\":\"23:59:52\",\"matchValue\":\"2,3\",\"priority\":0,\"effectTimeStart\":\"10:24:52\",\"valid\":1,\"modifyTime\":1618021565000,\"createTime\":1618021565000,\"appid\":\"wx056e868bb428ae64\",\"ruleName\":\"22\",\"id\":2,\"replyContent\":\"媒体素材media_id<a href=\\\"链接地址\\\">链接文字</a>\",\"desc\":\"1\",\"status\":true}', '{\"code\":200,\"data\":1,\"message\":\"操作成功\"}', '1', '', '2021-04-16 15:50:46', '2021-04-16 15:50:46', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
                            `id` bigint(20) NOT NULL AUTO_INCREMENT,
                            `name` varchar(100) DEFAULT NULL COMMENT '名称',
                            `role_key` varchar(100) DEFAULT NULL COMMENT '角色权限字符',
                            `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 ）',
                            `description` varchar(500) DEFAULT NULL COMMENT '描述',
                            `admin_count` int(11) DEFAULT NULL COMMENT '后台用户数量',
                            `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                            `status` char(1) DEFAULT '1' COMMENT '启用状态：0->禁用；1->启用',
                            `sort` int(11) DEFAULT '0' COMMENT '排序',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='后台用户角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '超级管理员', 'admin', '1', '超级管理员 admin', NULL, '2019-10-28 14:09:00', '1', 1);
INSERT INTO `sys_role` VALUES (2, '测试', 'test', '3', '测试', NULL, '2020-02-19 11:44:23', '1', 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
                                 `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                 `role_id` bigint(20) NOT NULL,
                                 `dept_id` bigint(20) NOT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色部门关联';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
                                 `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                 `role_id` bigint(20) DEFAULT NULL,
                                 `menu_id` bigint(20) DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COMMENT='后台用户角色和权限关系表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (22, 2, 1001);
INSERT INTO `sys_role_menu` VALUES (23, 2, 1008);
INSERT INTO `sys_role_menu` VALUES (24, 2, 1013);
INSERT INTO `sys_role_menu` VALUES (25, 2, 1017);
INSERT INTO `sys_role_menu` VALUES (26, 2, 1026);
INSERT INTO `sys_role_menu` VALUES (27, 2, 1031);
INSERT INTO `sys_role_menu` VALUES (28, 2, 1040);
INSERT INTO `sys_role_menu` VALUES (29, 2, 1043);
INSERT INTO `sys_role_menu` VALUES (30, 2, 1046);
INSERT INTO `sys_role_menu` VALUES (31, 2, 5);
INSERT INTO `sys_role_menu` VALUES (32, 2, 120);
INSERT INTO `sys_role_menu` VALUES (33, 2, 1063);
INSERT INTO `sys_role_menu` VALUES (34, 2, 121);
INSERT INTO `sys_role_menu` VALUES (35, 2, 1065);
INSERT INTO `sys_role_menu` VALUES (36, 2, 1066);
INSERT INTO `sys_role_menu` VALUES (37, 2, 122);
INSERT INTO `sys_role_menu` VALUES (38, 2, 1068);
INSERT INTO `sys_role_menu` VALUES (39, 2, 1069);
INSERT INTO `sys_role_menu` VALUES (40, 2, 1070);
INSERT INTO `sys_role_menu` VALUES (41, 2, 1071);
INSERT INTO `sys_role_menu` VALUES (42, 2, 123);
INSERT INTO `sys_role_menu` VALUES (43, 2, 1073);
INSERT INTO `sys_role_menu` VALUES (44, 2, 1074);
INSERT INTO `sys_role_menu` VALUES (45, 2, 1075);
INSERT INTO `sys_role_menu` VALUES (46, 2, 1076);
INSERT INTO `sys_role_menu` VALUES (47, 2, 124);
INSERT INTO `sys_role_menu` VALUES (48, 2, 1078);
INSERT INTO `sys_role_menu` VALUES (49, 2, 1079);
INSERT INTO `sys_role_menu` VALUES (50, 2, 1080);
INSERT INTO `sys_role_menu` VALUES (51, 2, 1081);
INSERT INTO `sys_role_menu` VALUES (52, 2, 125);
INSERT INTO `sys_role_menu` VALUES (53, 2, 1083);
INSERT INTO `sys_role_menu` VALUES (54, 2, 1084);
INSERT INTO `sys_role_menu` VALUES (55, 2, 1085);
INSERT INTO `sys_role_menu` VALUES (56, 2, 1086);
INSERT INTO `sys_role_menu` VALUES (57, 2, 126);
INSERT INTO `sys_role_menu` VALUES (58, 2, 1088);
INSERT INTO `sys_role_menu` VALUES (59, 2, 1089);
INSERT INTO `sys_role_menu` VALUES (60, 2, 1090);
INSERT INTO `sys_role_menu` VALUES (61, 2, 1091);
INSERT INTO `sys_role_menu` VALUES (62, 2, 1);
INSERT INTO `sys_role_menu` VALUES (63, 2, 100);
INSERT INTO `sys_role_menu` VALUES (64, 2, 101);
INSERT INTO `sys_role_menu` VALUES (65, 2, 102);
INSERT INTO `sys_role_menu` VALUES (66, 2, 103);
INSERT INTO `sys_role_menu` VALUES (67, 2, 105);
INSERT INTO `sys_role_menu` VALUES (68, 2, 106);
INSERT INTO `sys_role_menu` VALUES (69, 2, 108);
INSERT INTO `sys_role_menu` VALUES (70, 2, 500);
INSERT INTO `sys_role_menu` VALUES (71, 2, 501);
INSERT INTO `sys_role_menu` VALUES (72, 2, 2);
INSERT INTO `sys_role_menu` VALUES (73, 2, 109);
COMMIT;

-- ----------------------------
-- Table structure for sys_sms_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_sms_log`;
CREATE TABLE `sys_sms_log` (
                               `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '短信记录id',
                               `mobiles` varchar(500) DEFAULT NULL COMMENT '手机号',
                               `param` varchar(500) DEFAULT NULL COMMENT '参数',
                               `content` varchar(255) DEFAULT NULL COMMENT '短信内容',
                               `type` tinyint(3) DEFAULT NULL COMMENT '短信类型 10 单发 20 群发',
                               `type_name` varchar(20) DEFAULT NULL COMMENT '短信类型名称',
                               `template_code` varchar(64) DEFAULT NULL COMMENT '模板号',
                               `status` char(1) DEFAULT NULL COMMENT '结果成功失败 0 失败 1 成功',
                               `result` varchar(255) DEFAULT NULL COMMENT '第三方返回结果',
                               `source` tinyint(3) DEFAULT NULL COMMENT '来源平台',
                               `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                               `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                               `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                               PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='短信日志表';

-- ----------------------------
-- Records of sys_sms_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_sms_template
-- ----------------------------
DROP TABLE IF EXISTS `sys_sms_template`;
CREATE TABLE `sys_sms_template` (
                                    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
                                    `value` bigint(20) NOT NULL COMMENT '编号',
                                    `name` varchar(64) DEFAULT NULL COMMENT '作用',
                                    `sign_name` varchar(64) DEFAULT NULL COMMENT '短信签名',
                                    `source` tinyint(3) DEFAULT NULL COMMENT '来源平台',
                                    `template_code` varchar(64) DEFAULT NULL COMMENT '短信模板CODE',
                                    `content` varchar(255) DEFAULT NULL COMMENT '模板内容',
                                    `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                    `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                    `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                                    PRIMARY KEY (`id`) USING BTREE,
                                    UNIQUE KEY `value` (`value`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='短信模板';

-- ----------------------------
-- Records of sys_sms_template
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
                            `id` bigint(20) NOT NULL AUTO_INCREMENT,
                            `username` varchar(64) DEFAULT NULL COMMENT '用户名',
                            `password` varchar(64) DEFAULT NULL COMMENT '密码',
                            `dept_id` bigint(20) DEFAULT NULL COMMENT '所属部门',
                            `dept_name` varchar(255) DEFAULT NULL COMMENT '所属部门名称',
                            `post_ids` varchar(255) DEFAULT NULL COMMENT '岗位组',
                            `icon` varchar(500) DEFAULT NULL COMMENT '头像',
                            `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
                            `phone` varchar(11) DEFAULT NULL COMMENT '手机号',
                            `nick_name` varchar(200) DEFAULT NULL COMMENT '昵称',
                            `sex` varchar(1) DEFAULT NULL COMMENT '性别: 0 男,1 女,2 未知',
                            `note` varchar(500) DEFAULT NULL COMMENT '备注信息',
                            `status` char(1) DEFAULT '1' COMMENT '帐号启用状态：0->禁用；1->启用',
                            `login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
                            `login_ip` varchar(255) DEFAULT NULL COMMENT '最后登陆IP',
                            `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                            `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                            `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                            PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COMMENT='后台用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '$2a$10$x3bWW9r16kkukdCZdrVV9exxRerY7R.tf4tAi6flzTyfCCaBg.baS', 1, 'Harry科技', 'null', '', '183865800@qq.com', '17777777777', 'Harry', '0', 'assa的收到dfsd s', '1', '2019-09-29 13:55:39', NULL, '2019-09-29 13:55:30', '2020-04-27 16:10:46', 1);
INSERT INTO `sys_user` VALUES (101, 'harry', '$2a$10$1xY1gbC84uP71SH0AwzSIeKjfqYzhUP0Bff2YgNaQkXbCk2/wkhVC', 2, '研发部', '[\"2\"]', '', '183865800@qq.com', '17777777777', 'Harry测试', '1', 'assa的收到dfsd', '1', '2019-09-29 13:55:39', NULL, '2019-09-29 13:55:30', '2020-04-29 14:04:06', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_login_log`;
CREATE TABLE `sys_user_login_log` (
                                      `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                      `keyword` varchar(1000) DEFAULT NULL COMMENT 'key',
                                      `user_id` bigint(20) DEFAULT NULL,
                                      `username` varchar(64) DEFAULT NULL COMMENT '用户名',
                                      `nick_name` varchar(200) DEFAULT NULL COMMENT '昵称',
                                      `ip` varchar(64) DEFAULT NULL COMMENT '登陆IP',
                                      `address` varchar(100) DEFAULT NULL COMMENT '登陆地点',
                                      `user_agent` varchar(100) DEFAULT NULL COMMENT '浏览器登录类型',
                                      `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                      `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                      `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COMMENT='后台用户登录日志表';

-- ----------------------------
-- Records of sys_user_login_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
                                 `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                 `user_id` bigint(20) DEFAULT NULL,
                                 `role_id` bigint(20) DEFAULT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='后台用户和角色关系表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (2, 101, 2);
COMMIT;

-- ----------------------------
-- Table structure for wx_account
-- ----------------------------
DROP TABLE IF EXISTS `wx_account`;
CREATE TABLE `wx_account` (
                              `id` bigint(20) NOT NULL AUTO_INCREMENT,
                              `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
                              `appid` char(20) NOT NULL COMMENT 'appid',
                              `name` varchar(50) NOT NULL COMMENT '公众号名称',
                              `type` tinyint(1) unsigned DEFAULT '1' COMMENT '账号类型',
                              `verified` tinyint(1) unsigned DEFAULT '1' COMMENT '认证状态',
                              `secret` char(32) NOT NULL COMMENT 'appsecret',
                              `token` varchar(32) DEFAULT NULL COMMENT 'token',
                              `aes_key` varchar(43) DEFAULT NULL COMMENT 'aesKey',
                              `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                              `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                              `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                              PRIMARY KEY (`id`) USING BTREE,
                              UNIQUE KEY `idx_appid` (`appid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='公众号账号';

-- ----------------------------
-- Records of wx_account
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wx_msg
-- ----------------------------
DROP TABLE IF EXISTS `wx_msg`;
CREATE TABLE `wx_msg` (
                          `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
                          `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',
                          `openid` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '微信用户ID',
                          `in_out` tinyint(1) unsigned DEFAULT NULL COMMENT '消息方向',
                          `msg_type` char(25) CHARACTER SET utf8 DEFAULT NULL COMMENT '消息类型',
                          `detail` json DEFAULT NULL COMMENT '消息详情',
                          `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                          `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                          `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                          PRIMARY KEY (`id`) USING BTREE,
                          KEY `idx_appid` (`appid`) USING BTREE COMMENT 'appid'
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COMMENT='微信消息';

-- ----------------------------
-- Records of wx_msg
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wx_msg_reply_rule
-- ----------------------------
DROP TABLE IF EXISTS `wx_msg_reply_rule`;
CREATE TABLE `wx_msg_reply_rule` (
                                     `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
                                     `appid` char(20) DEFAULT '' COMMENT 'appid',
                                     `rule_name` varchar(20) NOT NULL COMMENT '规则名称',
                                     `match_value` varchar(200) NOT NULL COMMENT '匹配的关键词、事件等',
                                     `exact_match` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否精确匹配',
                                     `reply_type` varchar(20) NOT NULL DEFAULT '1' COMMENT '回复消息类型',
                                     `reply_content` varchar(1024) NOT NULL COMMENT '回复消息内容',
                                     `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '规则是否有效',
                                     `desc` varchar(255) DEFAULT NULL COMMENT '备注说明',
                                     `effect_time_start` time DEFAULT '00:00:00' COMMENT '生效起始时间',
                                     `effect_time_end` time DEFAULT '23:59:59' COMMENT '生效结束时间',
                                     `priority` int(3) unsigned DEFAULT '0' COMMENT '规则优先级',
                                     `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                     `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                     `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                                     PRIMARY KEY (`id`) USING BTREE,
                                     KEY `idx_appid` (`appid`) USING BTREE COMMENT 'appid'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='自动回复规则';

-- ----------------------------
-- Records of wx_msg_reply_rule
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wx_msg_template
-- ----------------------------
DROP TABLE IF EXISTS `wx_msg_template`;
CREATE TABLE `wx_msg_template` (
                                   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
                                   `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',
                                   `template_id` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '公众号模板ID',
                                   `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '模版名称',
                                   `title` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '标题',
                                   `content` text CHARACTER SET utf8 COMMENT '模板内容',
                                   `data` json DEFAULT NULL COMMENT '消息内容',
                                   `url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '链接',
                                   `miniprogram` json DEFAULT NULL COMMENT '小程序信息',
                                   `status` tinyint(1) unsigned NOT NULL COMMENT '是否有效',
                                   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                   `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                   `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                                   PRIMARY KEY (`id`) USING BTREE,
                                   UNIQUE KEY `idx_name` (`name`) USING BTREE COMMENT '模板名称',
                                   KEY `idx_status` (`status`) USING BTREE COMMENT '模板状态',
                                   KEY `idx_appid` (`appid`) USING BTREE COMMENT 'appid'
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COMMENT='消息模板';

-- ----------------------------
-- Records of wx_msg_template
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wx_qr_code
-- ----------------------------
DROP TABLE IF EXISTS `wx_qr_code`;
CREATE TABLE `wx_qr_code` (
                              `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                              `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',
                              `is_temp` tinyint(1) DEFAULT NULL COMMENT '是否为临时二维码',
                              `scene_str` varchar(64) DEFAULT NULL COMMENT '场景值ID',
                              `ticket` varchar(255) DEFAULT NULL COMMENT '二维码ticket',
                              `url` varchar(255) DEFAULT NULL COMMENT '二维码图片解析后的地址',
                              `expire_time` datetime DEFAULT NULL COMMENT '该二维码失效时间',
                              `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                              `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                              `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                              PRIMARY KEY (`id`) USING BTREE,
                              KEY `idx_appid` (`appid`) USING BTREE COMMENT 'appid'
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='公众号带参二维码';

-- ----------------------------
-- Records of wx_qr_code
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wx_template_msg_log
-- ----------------------------
DROP TABLE IF EXISTS `wx_template_msg_log`;
CREATE TABLE `wx_template_msg_log` (
                                       `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                       `appid` char(20) NOT NULL COMMENT 'appid',
                                       `touser` varchar(50) DEFAULT NULL COMMENT '用户openid',
                                       `template_id` varchar(50) DEFAULT NULL COMMENT 'templateid',
                                       `data` json DEFAULT NULL COMMENT '消息数据',
                                       `url` varchar(255) DEFAULT NULL COMMENT '消息链接',
                                       `miniprogram` json DEFAULT NULL COMMENT '小程序信息',
                                       `send_time` datetime DEFAULT NULL COMMENT '发送时间',
                                       `send_result` varchar(255) DEFAULT NULL COMMENT '发送结果',
                                       `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                       `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                                       `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                                       PRIMARY KEY (`id`) USING BTREE,
                                       KEY `idx_appid` (`appid`) USING BTREE COMMENT 'appid'
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='微信模版消息发送记录';

-- ----------------------------
-- Records of wx_template_msg_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wx_user
-- ----------------------------
DROP TABLE IF EXISTS `wx_user`;
CREATE TABLE `wx_user` (
                           `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                           `openid` varchar(50) NOT NULL COMMENT '微信openid',
                           `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',
                           `phone` char(11) DEFAULT NULL COMMENT '手机号',
                           `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
                           `sex` tinyint(4) DEFAULT NULL COMMENT '性别(0-未知、1-男、2-女)',
                           `city` varchar(20) DEFAULT NULL COMMENT '城市',
                           `province` varchar(20) DEFAULT NULL COMMENT '省份',
                           `headimgurl` varchar(255) DEFAULT NULL COMMENT '头像',
                           `subscribe_time` datetime DEFAULT NULL COMMENT '订阅时间',
                           `subscribe` tinyint(3) unsigned DEFAULT '1' COMMENT '是否关注',
                           `unionid` varchar(50) DEFAULT NULL COMMENT 'unionid',
                           `remark` varchar(255) DEFAULT NULL COMMENT '备注',
                           `tagid_list` json DEFAULT NULL COMMENT '标签ID列表',
                           `subscribe_scene` varchar(50) DEFAULT NULL COMMENT '关注场景',
                           `qr_scene_str` varchar(64) DEFAULT NULL COMMENT '扫码场景值',
                           `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                           `modify_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
                           `valid` int(1) DEFAULT '1' COMMENT '有效状态：0->无效；1->有效',
                           PRIMARY KEY (`id`) USING BTREE,
                           KEY `idx_unionid` (`unionid`) USING BTREE COMMENT 'unionid',
                           KEY `idx_appid` (`appid`) USING BTREE COMMENT 'appid'
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of wx_user
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;